package com.sinosoft.perfect.system._resource;

import java.sql.SQLException;
import java.util.List;

import com.sinosoft.perfect.system._.po.TResourceSystem;
import com.sinosoft.perfect.system._.po.TResourceSystemImg;


public interface MapperSystemResource {

	public Object selectTResourceMAXSortNum(TResourceSystem tresourcesystem) throws SQLException;

	public Object insertTResource(TResourceSystem tresourcesystem) throws SQLException;

	public List<TResourceSystem> selectTResource(TResourceSystem tresourcesystem) throws SQLException;

	public List<TResourceSystem> selectTResourceAndChildren(String resourceId) throws SQLException;
	
	public List<TResourceSystem> selectTResourceAndParents(String resourceId) throws SQLException;

	public Object selectTResourceSortNum(TResourceSystem tresourcesystem) throws SQLException;

	public Object selectTResourceSortNumMin(TResourceSystem tresourcesystem) throws SQLException;

	public Object selectTResourceByName(TResourceSystem tresourcesystem) throws SQLException;

	public Object selectTResourceSortNumByName(TResourceSystem tresourcesystem) throws SQLException;

	public int updateTResourceNotNullByPK(TResourceSystem tresourcesystem) throws SQLException;

	public void updateTResourceAndChildrenStatus(TResourceSystem tresourcesystem) throws SQLException;

	public int deleteTRoleResourcesByResourceId(String resourceId) throws SQLException;

	public int deleteTResourcesByResourceId(String resourceId) throws SQLException;
	
	public Object insertTResourceImg(TResourceSystemImg tresourceSystemImg) throws SQLException;
	public int updateTResourceImg(TResourceSystemImg tresourceSystemImg) throws SQLException;
	public int deleteTResourceImg(TResourceSystemImg tresourceSystemImg) throws SQLException;
	public List<TResourceSystemImg> selectTResourceImg(TResourceSystemImg tresourceSystemImg) throws SQLException;
}
